﻿CREATE TABLE [dbo].[Company] (
    [Id]             INT             IDENTITY (1, 1) NOT FOR REPLICATION NOT NULL,
    [CompanyAllName] NVARCHAR (50)   NULL,
    [CompanyName]    NVARCHAR (50)   NULL,
    [Startletter]    NVARCHAR (50)   NULL,
    [CompanyNumber]  NVARCHAR (50)   NULL,
    [CompanyPhone]   NVARCHAR (50)   NULL,
    [CompanyFax]     NVARCHAR (50)   NULL,
    [CompanyAddress] NVARCHAR (100)  NULL,
    [Zip]            NVARCHAR (10)   NULL,
    [ContactPerson]  NVARCHAR (50)   NULL,
    [ContactPhone]   NVARCHAR (50)   NULL,
    [ContactEmail]   NVARCHAR (50)   NULL,
    [WebAddress]     NVARCHAR (50)   NULL,
    [Products]       NVARCHAR (2000) NULL,
    [Mid]            INT             CONSTRAINT [DF_Company_Mid] DEFAULT ((0)) NULL,
    [dwbh]           VARCHAR (30)    NULL,
    [CompanyFR]      NVARCHAR (50)   CONSTRAINT [DF_Company_CompanyFR_1] DEFAULT ('') NULL,
    [createdate]     DATETIME        CONSTRAINT [DF_Company_createdate_1] DEFAULT (getdate()) NULL,
    [lrrq]           DATETIME        CONSTRAINT [DF_Company_lrrq_1] DEFAULT (getdate()) NULL,
    [Cid]            VARCHAR (10)    CONSTRAINT [DF_Company_Cid] DEFAULT ('') NULL,
    CONSTRAINT [PK_Company] PRIMARY KEY CLUSTERED ([Id] ASC)
);


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'编号（01，02，03）', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Company', @level2type = N'COLUMN', @level2name = N'dwbh';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'法人', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Company', @level2type = N'COLUMN', @level2name = N'CompanyFR';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'建立日期', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Company', @level2type = N'COLUMN', @level2name = N'createdate';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'录入日期', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Company', @level2type = N'COLUMN', @level2name = N'lrrq';

